CREATE TABLE [dbo].[Name_Research]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_ID] DEFAULT (''),
[ETHNICITY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_ETHNICITY] DEFAULT (''),
[EDUC_LEVEL] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_EDUC_LEVEL] DEFAULT (''),
[MARITAL_STATUS] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_MARITAL_STATUS] DEFAULT (''),
[PRIMARY_DOCTOR] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_PRIMARY_DOCTOR] DEFAULT (''),
[PRIMARY_INCOME] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_PRIMARY_INCOME] DEFAULT (''),
[NUM_SUPPORTED] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_NUM_SUPPORTED] DEFAULT (''),
[HEALTH_BENEFIT] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_HEALTH_BENEFIT] DEFAULT (''),
[LOST_BENEFIT] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_LOST_BENEFIT] DEFAULT (''),
[REFERRED_VOCREHAB] [bit] NOT NULL CONSTRAINT [DF_Name_Research_REFERRED_VOCREHAB] DEFAULT ((0)),
[LIVING_SITUATION] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_LIVING_SITUATION] DEFAULT (''),
[PRIMARY_LANGUAGE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_PRIMARY_LANGUAGE] DEFAULT (''),
[TOTAL_INCOME] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_TOTAL_INCOME] DEFAULT (''),
[FIRST_CONTACT] [datetime] NULL,
[DIAGNOSIS_DATE] [datetime] NULL,
[SYMPTOM_ONSET] [datetime] NULL,
[FAMILY_HISTORY] [bit] NOT NULL CONSTRAINT [DF_Name_Research_FAMILY_HISTORY] DEFAULT ((0)),
[DIAGNOSIS_MADE_BY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_DIAGNOSIS_MADE_BY] DEFAULT (''),
[SECONDARY_MEDICAL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Research_SECONDARY_MEDICAL] DEFAULT (''),
[NUMBER_EMPLOYEES] [int] NOT NULL CONSTRAINT [DF_Name_Research_NUMBER_EMPLOYEES] DEFAULT ((0)),
[EARNED_ASSETS] [money] NOT NULL CONSTRAINT [DF_Name_Research_EARNED_ASSETS] DEFAULT ((0)),
[RESEARCH_NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_Research] ADD CONSTRAINT [PK_Name_Research] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Name_Research] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Research] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Research] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Research] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Research] TO [IMIS]
GO